package smartagdemo.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import smartagdemo.bean.HumidityData;
import smartagdemo.bean.LightData;
import smartagdemo.bean.TemperatureData;
import smartagdemo.bean.TestData;

import java.sql.Timestamp;
import java.util.List;

@Mapper
public interface ViewMapper {
    List<TestData> viewTestData(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<HumidityData> viewHumidityData(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<TemperatureData> viewTemperatureData(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<LightData> viewLightData(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<HumidityData> viewDateHumidity(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<TemperatureData> viewDateTemperature(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
    List<LightData> viewDateLight(@Param("date1")Timestamp date1, @Param("date2")Timestamp date2);
}
